package t327.mapper;

import t327.pojo.SampleSheet;
import t327.pojo.StyleNumSizeChart;
import t327.pojo.StyleNumber;
import t327.pojo.views.SampleSheetListView;

import java.util.List;

public interface SampleSheetMapper {
    List<SampleSheetListView> getAllSampleSheetList();
    SampleSheetListView getSampleSheetById(Long sampleSheetId);
    int updateSubmitStatus(Long sampleSheetId);
    int addSampleSheet(SampleSheet sampleSheet);
    //根据款号查询所需尺码数量(笨方法，后续有思路再来改)
    StyleNumSizeChart StyleNumSizeByS(Long styleNumberId);//S码
    StyleNumSizeChart StyleNumSizeByM(Long styleNumberId);//M码
    StyleNumSizeChart StyleNumSizeByL(Long styleNumberId);//L码
    StyleNumSizeChart StyleNumSizeByXL(Long styleNumberId);//XL码
    StyleNumSizeChart StyleNumSizeByXXL(Long styleNumberId);//XXL码
    StyleNumSizeChart StyleNumSizeBy3XL(Long styleNumberId);//3XL码
    StyleNumSizeChart StyleNumSizeBy4XL(Long styleNumberId);//4XL码
    List<SampleSheetListView> getSheetListView(SampleSheetListView sampleSheetListView);
}
